How To Use AutoFill on a Google Docs Spreadsheet [Quick Tips]
Posted
by The Geek
on How to geek
See other posts from How to geek
or by The Geek
Published on Wed, 28 Apr 2010 17:00:46 +0000
Indexed on
2010/04/28
17:13 UTC
Read the original article
Hit count: 378
Google Docs
Have you ever wanted to fill an entire row or column with a series of values? If you’re an Excel user, you can do the same thing in Google Docs. If you haven’t used either, here’s the quick way to do it.
Just type in a couple of numbers in sequence… 1 2 3 works pretty well. You could also put them across a row instead of down a column.
Then move your mouse over the dot in the corner until the pointer changes, then just drag it downward (or if you are filling a row instead, you can drag it to the right).
Let go of the mouse, and your data will be automatically filled in.
You could also make it skip by 1 instead, like 2 4 6 8, etc…
It all works the same way. Sadly there’s no really advanced options like Excel has, but for most uses, this is good enough. Also, we’re aware this is a very simple tip for most of you, but we’re trying to help the beginners out as well!
Similar Articles | Productive Geek Tips |
Latest Software Reviews | Tinyhacker Random Tips |
© How to geek or respective owner